home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Windows Expert
/
Windows Expert.iso
/
database
/
winsql11.zip
/
EXAMPLES.ZIP
/
QUERY16.SQL
< prev
Wrap
Text File
|
1991-05-30
|
191b
|
12 lines
create table temp (
pno char(6),
totqty integer
);
insert into temp (pno, totqty)
select pno, sum(qty) from sp group by pno;
select * from temp;
drop table temp;